Release 10.1A: OpenEdge Development:
Progress Dynamics Repository Reference

Table description

This table defines login companies (organizations) and provides a list of valid companies the user can log into at run time.

You can link this table into an external application database where additional details are stored for the login company, such as address and contact information. The code or the object field could be used as the cross-reference into the external application database. The Progress Dynamics framework uses this table in the generic setup of framework data specific to login companies, such as security allocations and automatic reference numbers.

The existence of a login company in the framework supports the concept of holding application data for multiple companies in a single database, instead of having separate databases for each company. Application databases have to link to this table, or a corresponding table in their database design, to filter appropriate data for each login company.

Table 18–5 lists the table’s FLA, fields, and foreign keys.

Table 18–5: gsm_login_company table information 

Table FLA	Fields (data type)	Foreign keys
gsmlg	login_company_obj (Decimal) login_company_code (Character) login_company_short_name (Character) login_company_name (Character) login_company_email (Character) login_company_disabled (Logical)	login_company_obj

Table 18–6 gives details of the table’s indexes.

Table 18–6: gsm_login_company index information 

Index name	Elements	Type
XPKgsm_login_company	login_company_obj	Primary Unique
XAK1gsm_login_company	login_company_code	Unique
XIE1gsm_login_company	login_company_short_name	Nonunique
XIE2gsm_login_company	login_company_name	Nonunique

This table only holds the minimum details required by the framework. In order to simplify and synchronize maintenance of this data, applications that also have an organization table should replicate modifications from their full organization table into this table.